Release 10.1A: OpenEdge Data Management:
Database Administration

PROMON shut down database option

You can use the PROMON utility to stop the database or disconnect any subset of users.

To shut down a database using PROMON:

Enter the following PROMON command:

promon db-name

When you start the monitor, the Database Monitor main menu appears:

OpenEdge MONITOR Version 10   Database: usr1/WRK/sports2000   1. User Control   2. Locking and Waiting Statistics   3. Block Access   4. Record Locking Table   5. Activity   6. Shared Resources   7. Database Status   8. Shut Down Database R&D.  Advanced Options   T. Transaction Control   L. Resolve Limbo Transactions   C. Coordinator Information   M.  Modify Defaults   Q. Quit   Enter your selection:

Choose option 8, Shut Down Database.

The following figure shows an example of this option’s output:

Enter your selection: 8 Usr PID      Time of login Userid tty             Limbo? 1 6358     Dec 14 15:10:52 sue /dev/ttyp0      no 4 7007     Dec 14 15:25:09 mary /dev/ttyp5      no                 1 Disconnect a User                 2 Unconditional Shutdown                 3 Emergency Shutdown (Kill All)                 4 Exit Enter choice>

Choose an option.

If you choose 1 (Disconnect a User), the system prompts you for a user number. Choose 2 (Unconditional Shutdown) to stop all users and shut down the database. If you have multiple remote-user servers, this stops all the servers.